/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package camada.bancodedados.daoimplemente.servico.orcamento;

import camada.negocio.dao.servico.orcamento.ServicoOrcamentoDAO;
import eloma.classe.servico.orcamento.ServicoOrcamento;
import java.sql.PreparedStatement;

/**
 *
 * @author Ícaro
 */
public class ServicoOrcamentoDAOImpl implements ServicoOrcamentoDAO {
////    
////       //<editor-fold desc="Metodos Basicos">
////    
////    @Override
////    //<editor-fold desc="Metodo Inserir Servico Orcamento">
////    public void inserirServicoOrcamento(ServicoOrcamento servicoOrcamento) {
////        PreparedStatement pstm = null;
////        try {
////            final String SQL_INSERIR_SERVICO =
////                    "INSERT INTO SERVICO(IDEMPRESA,IDCLIENTE,DATA,IDSERVICO_CATEGORIA,DESCRICAO,STATUS,AVALIACAO)values(?,?,?,?,?,?,?)";
////            pstm = (PreparedStatement) Conexao.getCon().prepareStatement(SQL_INSERIR_SERVICO);
////            pstm.setInt(1, servico.getIdEmpresa());
////            pstm.setInt(2, servico.getCliente().getIdCliente());
////            java.sql.Date dataSql = new java.sql.Date(servico.getDataServico().getDate());
////            pstm.setDate(3, dataSql);
////            pstm.setInt(4, servico.getServicoCategoria().getIdServicoCategoria());
////            pstm.setString(5, servico.getDecricao());
////            pstm.setInt(6, servico.getStatus());
////            pstm.setString(7, servico.getAvaliacao());
////            pstm.executeUpdate();
////
////        } catch (SQLException e) {
////            String w = e.getMessage();
////        }
////    }
////    //</editor-fold>
////
////    @Override
////    //<editor-fold desc="Metodo Atualizar Servico">
////    public void atualizarServicoOrcamento(Servico servico) {
////        PreparedStatement pstm = null;
////        try {
////            final String SQL_UPDATE =
////                    "UPDATE SERVICO SET IDEMPRESA = ? ,IDCLIENTE = ? ,DATA = ? ,IDSERVICO_CATEGORIA = ? ,DESCRICAO = ? ,STATUS = ? ,AVALIACAO = ? WHERE IDSERVICO = ? ";
////            pstm = (PreparedStatement) Conexao.getCon().prepareStatement(SQL_UPDATE);
////            pstm.setInt(1, servico.getIdEmpresa());
////            pstm.setInt(2, servico.getCliente().getIdCliente());
////            java.sql.Date dataSql = new java.sql.Date(servico.getDataServico().getDate());
////            pstm.setDate(3, dataSql);
////            pstm.setInt(4, servico.getServicoCategoria().getIdServicoCategoria());
////            pstm.setString(5, servico.getDecricao());
////            pstm.setInt(6, servico.getStatus());
////            pstm.setString(7, servico.getAvaliacao());
////            pstm.executeUpdate();
////        } catch (SQLException e) {
////        }
////    }
////    //</editor-fold>
////
////    @Override
////    //<editor-fold desc="Metodo Remover Servico">
////    public void removerServicoOrcamento(int idServicoOrcamento) {
////        PreparedStatement pstm = null;
////        try {
////            final String SQL_DELETE = "DELETE FROM SERVICO WHERE IDSERVICO = ?";
////            pstm = (PreparedStatement) Conexao.getCon().prepareStatement(SQL_DELETE);
////            pstm.setInt(1, idServico);
////            pstm.executeUpdate();
////        } catch (SQLException e) {
////        }
////    }
////    //</editor-fold>
////
////    //</editor-fold>

}
